Hệ thống quản lý chứng khoán Dự án Java

19.507 lượt xem;

stock_sales_delete.php
project /

1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8     include_once "db.php";
9     error_reporting (E_ALL ^ E_NOTICE);
10     if(isset($_GET['tid']) && isset($_GET['table']))
11     {
12     $tid=$_GET['tid'];
13     $tablename=$_GET['table'];
14     $return=$_GET['return'];
15
16     $result =$db->query("SELECT * FROM stock_sales WHERE transactionid='$tid'");
17   while ($line = $db->fetchNextObject($result)) {
18
19
20                 $difference=$db->queryUniqueValue("SELECT quantity FROM stock_sales WHERE id=$line->id");
21                 echo "SELECT id FROM stock_entries WHERE salesid='$tid' and stock_name='$line->stock_name'";
22                 $id=$db->queryUniqueValue("SELECT id FROM stock_entries WHERE salesid='$tid' and stock_name='$line->stock_name'");
23
24                 $name=$line->stock_name;
25                 $result1=$db->query("SELECT * FROM stock_entries where id > $id");
26                 while ($line2 = $db->fetchNextObject($result1)) {
27                 $osd=$line2->opening_stock + $difference;
28                 $csd=$line2->closing_stock + $difference;
29                 $cid=$line2->id;
30                 $db->execute("UPDATE stock_entries SET opening_stock=".$osd.",closing_stock=".$csd." WHERE id=$cid");
31
32                 }
33
34                 $total = $db->queryUniqueValue("SELECT quantity FROM stock_avail WHERE name='$name'");
35                 $total = $total + $difference;
36                 $db->execute("UPDATE stock_avail SET quantity=$total WHERE name='$name'");
37                 $db->execute("DELETE FROM $tablename WHERE id=$line->id");
38                 $db->execute("DELETE FROM stock_entries WHERE salesid='$tid' and stock_name='$line->stock_name'");
39
40                 }
41
42
43
44
45     header("location:$return?msg=Record Deleted Successfully!&id=$tid");
46
47         }
48
49
50 }
51 ?>